You could use a check constraint, or a foreign key. Check constraint: alter table brands add country_name varchar(64) not null; ... ... <看更多>

Find if the column exists using the SQL below: SELECT column_name FROM INFORMATION_SCHEMA . ... MySQL - ALTER TABLE to add a column if it does not exist: ... <看更多>